Search results for "Visual Basic for Applications"
showing 5 items of 5 documents
Automatic regrouping of strata in the goodness-of-fit chi-square test
2019
Pearson’s chi-square test is widely employed in social and health sciences to analyze categorical data and contingency tables. For the test to be valid, the sample size must be large enough to provide a minimum number of expected elements per category. This paper develops functions for regrouping strata automatically no matter where they are located, thus enabling the goodness-of-fit test to be performed within an iterative procedure. The functions are written in Excel VBA (Visual Basic for Applications) and in Mathematica. The usefulness and performance of these functions is illustrated by means of a simulation study and the application to different datasets. Finally, the iterative use of …
A procedure to calculate the five-parameter model of crystalline silicon photovoltaic modules on the basis of the tabular performance data
2013
Abstract Only few manufactures provide the wide set of graphical data that are necessary to use high performance predictive tools for PV systems. On the other hand, reliable graphical data require accurate laboratory measurements that increase manufacturing costs. For this reason PV system designers have to choose between the use of cheap PV modules, lacking in technical data, and the reliable energy predictions that are possible only if the current–voltage characteristics are provided by the PV module manufacturers. This paper describes the procedure to evaluate the parameters of a one-diode equivalent circuit able to accurately represent the electrical behaviour of a PV panel by means of …
An improved five-parameter model for photovoltaic modules
2010
This paper presents a new five-parameter model capable of analytically describing the I–V characteristic of a photovoltaic module for each generic condition of operative temperature and solar irradiance. The parameters of the equivalent electrical circuit are extracted by solving a system of equations based on data commonly issued by manufacturers in standard rating conditions with a trial and error process. The procedure, which does not require any special equations solver, can be easily coded into a short software routine using simple languages and finds the solution of the system of equations with the desired accuracy without needing to be guided towards solutions starting from fitted in…
VBA-ohjelmoinnin mahdollisuudet raportoinnin ja etähuollon kehityksessä
2005
Excel ja laskenta pilvipalveluissa
2013
Tutkielma esittelee ja vertailee taulukkolaskenta-ohjelmien ohjelmointimahdollisuuksia. Taulukkolaskentaohjelmia on mahdollisuus käyttää perinteisenä työpöytäsovelluksena, pilvipalveluna verkkoselaimella sekä etäpalvelimen asiakasohjelmalla. Lisää suoritustehoa on saatavilla rinnakkaislaskennalla ja pilvipalveluntarjoajilta. The thesis examines and compares spreadsheet programs and their programming options. Spreadsheet programs have the option to use as a traditional desktop application, a web browser, as well as run the application server with remote client. More processing power is available by using parallel computing and from cloud service providers.